
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [dbo].[ServiceInfoInsert]
    @Id UNIQUEIDENTIFIER ,
    @UserInfoId UNIQUEIDENTIFIER ,
    @ServiceTypeId UNIQUEIDENTIFIER ,
    @Name VARBINARY(MAX),
    @Url VARBINARY(MAX),
    @IconImage IMAGE
AS 
    BEGIN
        INSERT  INTO ServiceInfo
                ( Id ,
                  UserInfoId ,
                  ServiceTypeId ,
                  Name ,
                  Url ,
                  IconImage ,
                  DateCreated ,
                  Deleted
                )
        VALUES  ( @Id ,
                  @UserInfoId ,
                  @ServiceTypeId ,
                  @Name ,
                  @Url ,
                  @IconImage ,
                  GETDATE() ,
                  0
                )
    END
GO
